package com.sec.etech.chain.customergroup.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sec.etech.chain.customergroup.entity.CustomerGroup;
import org.apache.ibatis.annotations.Select;

public interface CustomerGroupMapper extends BaseMapper<CustomerGroup> {
    @Select("SELECT IFNULL(customergroupcode,'') FROM `proj_project_z_customergroup` WHERE active = 1 AND customergroupcode LIKE 'PCG%' ORDER BY customergroupcode DESC LIMIT 1;")
    public String getCurrentCode();
}
